Show All
Value property as it applies to the ChSegmentBoundary object.
Returns or sets a Double that represents the value of the specified segment boundary. Read/write.
expression.Value
expression Required. An expression that returns a ChSegmentBoundary object.
Value property as it applies to the Name and Spreadsheet objects.
Returns a String that represents the name of the specified object. Read-only.
expression.Value
expression Required. An expression that returns one of the above objects.
Value property as it applies to the Borders, ByRef, ParameterValue, and PivotDetailCell objects.
Returns or sets a Variant that represents the value of the specified object. Read/write.
expression.Value
expression Required. An expression that returns one of the above objects.
Value property as it applies to the Range object.
Returns or sets a Variant that represents the value of the specified cell. Read/write.
expression.Value(RangeValueDataType)
expression Required. An expression that returns a Range object
RangeValueDataType Optional Variant. The range value data type.
If the specified range contains more than one cell, this property returns the value of the active cell in the range.
Returns a Variant that represents the value of the specified object. Read-only.
expression.Value
expression Required. An expression that returns one of the above objects.
This example creates a merged cell from the specified range and then places a value in the merged cell.
Sub MergeCells()
Spreadsheet1.Range("A1:C3").Merge
Spreadsheet1.Range("A1").Value = "Monday"
End Sub